Tabela OrgUnit

Definicja tabeli OrgUnit

Name

OrgUnit

Code

OrgUnit

Comment

 


Lista kolumn tabeli OrgUnit

Name

Code

OrgUnitID

OrgUnitID

HierarchyTypeID

HierarchyTypeID

Code

Code

InterfaceCd

InterfaceCd

ShortName

ShortName

FullName

FullName

Description

Description

Accounting

Accounting

Active

Active

CompanyStatisticalNo

CompanyStatisticalNo

TaxPayerID

TaxPayerID

Manager

Manager

StartDT

StartDT

StopDT

StopDT

UnitNo

UnitNo

StatCode

StatCode

Servicer

Servicer

BankAccount

BankAccount

CustomerContractNo

CustomerContractNo

IgnoreHISstats

IgnoreHISstats

CostStatus

CostStatus

CallCentreEnabled

CallCentreEnabled

Comments

Comments

IdentificationNo

IdentificationNo

HealthCareName

HealthCareName

HealthCareNameResort

HealthCareNameResort

OPK

OPK

WorkingHours

WorkingHours

ServiceScope

ServiceScope

BenefitProviderCode

BenefitProviderCode

StatCode7

StatCode7

StatCode8

StatCode8

StatCode9

StatCode9

StatCode10

StatCode10


Kolumna OrgUnitID tabeli OrgUnit

Definicja kolumny OrgUnitID tabeli OrgUnit

Name

OrgUnitID

Code

OrgUnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HierarchyTypeID tabeli OrgUnit

Definicja kolumny HierarchyTypeID tabeli OrgUnit

Name

HierarchyTypeID

Code

HierarchyTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli OrgUnit

Definicja kolumny Code tabeli OrgUnit

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna InterfaceCd tabeli OrgUnit

Definicja kolumny InterfaceCd tabeli OrgUnit

Name

InterfaceCd

Code

InterfaceCd

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna ShortName tabeli OrgUnit

Definicja kolumny ShortName tabeli OrgUnit

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna FullName tabeli OrgUnit

Definicja kolumny FullName tabeli OrgUnit

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Description tabeli OrgUnit

Definicja kolumny Description tabeli OrgUnit

Name

Description

Code

Description

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Accounting tabeli OrgUnit

Definicja kolumny Accounting tabeli OrgUnit

Name

Accounting

Code

Accounting

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Active tabeli OrgUnit

Definicja kolumny Active tabeli OrgUnit

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CompanyStatisticalNo tabeli OrgUnit

Definicja kolumny CompanyStatisticalNo tabeli OrgUnit

Name

CompanyStatisticalNo

Code

CompanyStatisticalNo

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna TaxPayerID tabeli OrgUnit

Definicja kolumny TaxPayerID tabeli OrgUnit

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Manager tabeli OrgUnit

Definicja kolumny Manager tabeli OrgUnit

Name

Manager

Code

Manager

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StartDT tabeli OrgUnit

Definicja kolumny StartDT tabeli OrgUnit

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli OrgUnit

Definicja kolumny StopDT tabeli OrgUnit

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna UnitNo tabeli OrgUnit

Definicja kolumny UnitNo tabeli OrgUnit

Name

UnitNo

Code

UnitNo

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StatCode tabeli OrgUnit

Definicja kolumny StatCode tabeli OrgUnit

Name

StatCode

Code

StatCode

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Servicer tabeli OrgUnit

Definicja kolumny Servicer tabeli OrgUnit

Name

Servicer

Code

Servicer

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna BankAccount tabeli OrgUnit

Definicja kolumny BankAccount tabeli OrgUnit

Name

BankAccount

Code

BankAccount

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CustomerContractNo tabeli OrgUnit

Definicja kolumny CustomerContractNo tabeli OrgUnit

Name

CustomerContractNo

Code

CustomerContractNo

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna IgnoreHISstats tabeli OrgUnit

Definicja kolumny IgnoreHISstats tabeli OrgUnit

Name

IgnoreHISstats

Code

IgnoreHISstats

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CostStatus tabeli OrgUnit

Definicja kolumny CostStatus tabeli OrgUnit

Name

CostStatus

Code

CostStatus

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna CallCentreEnabled tabeli OrgUnit

Definicja kolumny CallCentreEnabled tabeli OrgUnit

Name

CallCentreEnabled

Code

CallCentreEnabled

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Comments tabeli OrgUnit

Definicja kolumny Comments tabeli OrgUnit

Name

Comments

Code

Comments

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna IdentificationNo tabeli OrgUnit

Definicja kolumny IdentificationNo tabeli OrgUnit

Name

IdentificationNo

Code

IdentificationNo

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna HealthCareName tabeli OrgUnit

Definicja kolumny HealthCareName tabeli OrgUnit

Name

HealthCareName

Code

HealthCareName

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna HealthCareNameResort tabeli OrgUnit

Definicja kolumny HealthCareNameResort tabeli OrgUnit

Name

HealthCareNameResort

Code

HealthCareNameResort

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna OPK tabeli OrgUnit

Definicja kolumny OPK tabeli OrgUnit

Name

OPK

Code

OPK

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna WorkingHours tabeli OrgUnit

Definicja kolumny WorkingHours tabeli OrgUnit

Name

WorkingHours

Code

WorkingHours

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna ServiceScope tabeli OrgUnit

Definicja kolumny ServiceScope tabeli OrgUnit

Name

ServiceScope

Code

ServiceScope

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna BenefitProviderCode tabeli OrgUnit

Definicja kolumny BenefitProviderCode tabeli OrgUnit

Name

BenefitProviderCode

Code

BenefitProviderCode

Data Type

VARCHAR2(4)

Mandatory

No

Comment

Kod swiadczeniodawcy wlasciciela jednostki organizacyjnej


Kolumna StatCode7 tabeli OrgUnit

Definicja kolumny StatCode7 tabeli OrgUnit

Name

StatCode7

Code

StatCode7

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StatCode8 tabeli OrgUnit

Definicja kolumny StatCode8 tabeli OrgUnit

Name

StatCode8

Code

StatCode8

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StatCode9 tabeli OrgUnit

Definicja kolumny StatCode9 tabeli OrgUnit

Name

StatCode9

Code

StatCode9

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna StatCode10 tabeli OrgUnit

Definicja kolumny StatCode10 tabeli OrgUnit

Name

StatCode10

Code

StatCode10

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Lista kluczy tabeli OrgUnit

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OrgUnit

Definicja klucza Identifier_1 tabeli OrgUnit

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment